{
  "statement":"SELECT \n  t0_101.c_0_0 \nFROM \n  t0 AS t0_101 \nWHERE \n  (\n    (\n      (t0_101.c_0_0) IN (\n        (\n          SELECT \n            subt0.c_0_0 \n          FROM \n            (\n              SELECT \n                t0_101.c_0_0, \n                t0_101.c_0_1, \n                t0_101.c_0_2, \n                t0_101.c_0_3, \n                t0_101.c_0_4, \n                t0_101.c_0_5 \n              FROM \n                t0 AS t0_101 \n              WHERE \n                true\n            ) subt0 LEFT ANTI \n            JOIN t2 AS t2_103 ON subt0.c_0_1 \u003d t2_103.c_2_1 \n            AND subt0.c_0_1 \u003c\u003d t2_103.c_2_1 \n            AND subt0.c_0_1 \u003c t2_103.c_2_1 \n            AND subt0.c_0_1 \u003e\u003d t2_103.c_2_1 \n          WHERE \n            (\n              CASE WHEN (subt0.c_0_0) !\u003d (t0_101.c_0_0) THEN t0_101.c_0_3 ELSE subt0.c_0_3 END\n            ) IN (\u00271969-12-28\u0027)\n        )\n      )\n    ) IS NULL\n  )",
  "table_meta":{
    "w6.t0":"CREATE TABLE `t0` (\n  `c_0_0` date NULL COMMENT \"\",\n  `c_0_1` decimal128(32, 17) NULL COMMENT \"\",\n  `c_0_2` date NOT NULL COMMENT \"\",\n  `c_0_3` date NULL COMMENT \"\",\n  `c_0_4` date NULL COMMENT \"\",\n  `c_0_5` float NULL COMMENT \"\"\n) ENGINE\u003dOLAP \nDUPLICATE KEY(`c_0_0`, `c_0_1`, `c_0_2`, `c_0_3`)\nCOMMENT \"OLAP\"\nPARTITION BY RANGE(`c_0_0`)\n(PARTITION p20100101 VALUES [(\u00272010-01-01\u0027), (\u00272010-08-26\u0027)),\nPARTITION p20100826 VALUES [(\u00272010-08-26\u0027), (\u00272011-04-20\u0027)),\nPARTITION p20110420 VALUES [(\u00272011-04-20\u0027), (\u00272011-12-13\u0027)),\nPARTITION p20111213 VALUES [(\u00272011-12-13\u0027), (\u00272012-08-06\u0027)),\nPARTITION p20120806 VALUES [(\u00272012-08-06\u0027), (\u00272013-03-31\u0027)),\nPARTITION p20130331 VALUES [(\u00272013-03-31\u0027), (\u00272013-11-23\u0027)),\nPARTITION p20131123 VALUES [(\u00272013-11-23\u0027), (\u00272014-07-18\u0027)),\nPARTITION p20140718 VALUES [(\u00272014-07-18\u0027), (\u00272015-03-12\u0027)),\nPARTITION p20150312 VALUES [(\u00272015-03-12\u0027), (\u00272015-11-04\u0027)),\nPARTITION p20151104 VALUES [(\u00272015-11-04\u0027), (\u00272016-06-28\u0027)),\nPARTITION p20160628 VALUES [(\u00272016-06-28\u0027), (\u00272017-02-20\u0027)),\nPARTITION p20170220 VALUES [(\u00272017-02-20\u0027), (\u00272017-10-15\u0027)),\nPARTITION p20171015 VALUES [(\u00272017-10-15\u0027), (\u00272018-06-09\u0027)),\nPARTITION p20180609 VALUES [(\u00272018-06-09\u0027), (\u00272019-02-01\u0027)),\nPARTITION p20190201 VALUES [(\u00272019-02-01\u0027), (\u00272019-09-26\u0027)),\nPARTITION p20190926 VALUES [(\u00272019-09-26\u0027), (\u00272020-05-20\u0027)),\nPARTITION p20200520 VALUES [(\u00272020-05-20\u0027), (\u00272021-01-12\u0027)),\nPARTITION p20210112 VALUES [(\u00272021-01-12\u0027), (\u00272021-09-06\u0027)),\nPARTITION p20210906 VALUES [(\u00272021-09-06\u0027), (\u00272022-05-01\u0027)),\nPARTITION p20220501 VALUES [(\u00272022-05-01\u0027), (\u00272022-12-24\u0027)),\nPARTITION p20221224 VALUES [(\u00272022-12-24\u0027), (\u00272023-08-18\u0027)))\nDISTRIBUTED BY HASH(`c_0_1`, `c_0_3`, `c_0_2`, `c_0_0`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\"\n);",
    "w6.t2":"CREATE TABLE `t2` (\n  `c_2_0` datetime NOT NULL COMMENT \"\",\n  `c_2_1` boolean REPLACE NULL COMMENT \"\",\n  INDEX index1_c_2_0 (`c_2_0`) USING BITMAP\n) ENGINE\u003dOLAP \nAGGREGATE KEY(`c_2_0`)\nCOMMENT \"OLAP\"\nDISTRIBUTED BY HASH(`c_2_0`) BUCKETS 3 \nPROPERTIES (\n\"replication_num\" \u003d \"1\",\n\"in_memory\" \u003d \"false\",\n\"storage_format\" \u003d \"DEFAULT\",\n\"enable_persistent_index\" \u003d \"false\"\n);"
  },
  "table_row_count":{
    "w6.t2":{
      "t2":5
    }
  },
  "session_variables":"{\"enable_resource_group\":false,\"chunk_size\":4096,\"runtime_join_filter_push_down_limit\":1024000,\"global_runtime_filter_probe_min_selectivity\":0.5,\"enable_show_all_variables\":false,\"query_mem_limit\":0,\"cbo_cte_reuse\":true,\"enable_tablet_internal_parallel\":false,\"character_set_connection\":\"utf8\",\"cbo_use_correlated_join_estimate\":true,\"enable_insert_strict\":false,\"enable_filter_unused_columns_in_scan_stage\":false,\"div_precision_increment\":4,\"join_implementation_mode\":\"hash\",\"tx_isolation\":\"REPEATABLE-READ\",\"wait_timeout\":28800,\"cbo_cte_reuse_rate\":1.2,\"auto_increment_increment\":1,\"sql_mode_v2\":32,\"character_set_client\":\"utf8\",\"autocommit\":true,\"enable_column_expr_predicate\":false,\"character_set_results\":\"utf8\",\"pipeline_profile_level\":1,\"parallel_fragment_exec_instance_num\":1,\"max_scan_key_num\":-1,\"enable_global_runtime_filter\":true,\"net_read_timeout\":60,\"streaming_preaggregation_mode\":\"auto\",\"storage_engine\":\"olap\",\"enable_optimizer_trace_log\":false,\"cbo_enable_dp_join_reorder\":true,\"cbo_enable_low_cardinality_optimize\":true,\"tx_visible_wait_timeout\":10,\"cbo_max_reorder_node_use_exhaustive\":4,\"enable_sql_digest\":false,\"new_planner_optimize_timeout\":300000,\"profile_timeout\":2,\"force_schedule_local\":false,\"pipeline_dop\":0,\"enable_query_dump\":false,\"cbo_enable_greedy_join_reorder\":true,\"single_node_exec_plan\":false,\"load_mem_limit\":0,\"global_runtime_filter_build_max_size\":67108864,\"sql_select_limit\":9223372036854775807,\"statistic_collect_parallel\":1,\"sql_safe_updates\":0,\"query_cache_type\":0,\"disable_colocate_join\":false,\"max_pushdown_conditions_per_column\":-1,\"global_runtime_filter_probe_min_size\":102400,\"query_delivery_timeout\":300,\"net_write_timeout\":60,\"cbo_prune_shuffle_column_rate\":0.1,\"collation_database\":\"utf8_general_ci\",\"hash_join_push_down_right_table\":true,\"enable_exchange_pass_through\":true,\"new_planner_agg_stage\":0,\"use_compute_nodes\":-1,\"collation_connection\":\"utf8_general_ci\",\"resource_group\":\"\",\"broadcast_row_limit\":15000000,\"enable_predicate_reorder\":false,\"workgroup_id\":0,\"exec_mem_limit\":2147483648,\"cbo_max_reorder_node_use_dp\":10,\"runtime_filter_on_exchange_node\":false,\"disable_join_reorder\":false,\"enable_profile\":true,\"enable_hive_column_stats\":true,\"enable_groupby_use_output_alias\":false,\"net_buffer_length\":16384,\"transmission_compression_type\":\"LZ4\",\"interactive_timeout\":3600,\"forward_to_leader\":false,\"max_allowed_packet\":1048576,\"query_timeout\":60,\"cbo_max_reorder_node\":50,\"collation_server\":\"utf8_general_ci\",\"time_zone\":\"Asia/Shanghai\",\"character_set_server\":\"utf8\",\"enable_deliver_batch_fragments\":true,\"enable_pipeline\":true,\"cbo_use_nth_exec_plan\":0,\"parallel_exchange_instance_num\":-1,\"enable_shared_scan\":false,\"runtime_filter_scan_wait_time\":20,\"SQL_AUTO_IS_NULL\":false,\"event_scheduler\":\"OFF\",\"prefer_compute_node\":false,\"enable_query_debug_trace\":false,\"disable_streaming_preaggregations\":false,\"allow_default_partition\":false}",
  "column_statistics":{
    "w6.t2":{
      "c_2_1":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    },
    "w6.t0":{
      "c_0_3":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "c_0_1":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN",
      "c_0_0":"[-Infinity, Infinity, 0.0, 1.0, 1.0] UNKNOWN"
    }
  },
  "be_number":2,
  "exception":[

  ],
  "version":"UNKNOWN",
  "commit_version":"b4128c764"
}